<?php
$username = "blogbound";
$password = "Br4df0rd";
$database = "blogbound_com_-_blog";
$hostname = "127.0.0.1";

$query = "SELECT link_name, link_rss, link_url FROM manchester_links WHERE link_category=2";

mysql_connect($hostname, $username,$password);
@mysql_select_db($database) or die("Unable to select database");
$result = mysql_query($query);
$num = mysql_numrows($result);
mysql_close();

$i=0;
while($i < $num) {
	$rss = mysql_result($result,$i,"link_rss");
	$name = mysql_result($result,$i,"link_name");
    $url = mysql_result($result,$i,"link_url");

	#echo "<outline text=\"".$name."\" xmlUrl=\"".$rss."\" />\r\n";
    echo "<a href=\"".$rss."\">".$name."</a>\r\n";
    echo "<a href=\"".$url."\">".$name."</a>\r\n";
	$i++;
}
echo "</body></opml>";
?>
